========================================================================= Date: Tue, 31 Aug 1993 11:21:40 GMT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Richard Saunders, Computer Centre" Organization: University Of East London Subject: Re: Automatic field updates > For example: I enter John Doe into the database. When I get to the > Country field, I enter "Japan," since that's where he lives. Access should, > in the best of all possible worlds, then look in Table 2 for the entry > for Japan, which holds (in named fields, of course) the French name > and the telephone code. Access places these bits of data into the > appropriate fields in the original table so I don't have to do it, and > Bob's your uncle. I believe you've had some replies about displaying these fields on your form. What worries me a little bit is that you say you want to place the data into the appropriate fields in the original table. The whole idea of a relational database is that you DON'T duplicate data in different tables. ========================================================================= Date: Tue, 31 Aug 1993 12:48:47 GMT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Richard Saunders, Computer Centre" Organization: University Of East London Subject: Re: Maximize the form before opening form > > Does anyone know how to maximize the form before the form is opened ? > Normally Macro - openform & then maximize. > > It is so UGLY to see the "small" form being enlarge when you execute the macro . > Is there a way to see the maximized form on the screen once you execute the ma cr > o ? You could use ECHO to hide screen activity before you open and maximize the screen; then ECHO again to revert to normal. It looks a bit tidier that way. ========================================================================= Date: Wed, 1 Sep 1993 08:54:07 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Miller Organization: PictureTel Corporation Subject: Re: Maximize the form before opening form > > > > > Does anyone know how to maximize the form before the form is opened ? > > Normally Macro - openform & then maximize. > > > > It is so UGLY to see the "small" form being enlarge when you execute the > macro. > > Is there a way to see the maximized form on the screen once you execute the > macr > > o ? > > > > Chor Ling > > NCLCHAN@NTUVAX.NTU.AC.SG > > > > I've never tried it, but, you might be able to set the form's visible > property to false, maximize it, and then set the visible property to > true. You might also just want to store the forms with visible set to > false, open them, maximize them, set the visible property to true. You > probably want to set visible back to false when you close the form. > > John > This works unless the form is a pop-up form. For a pop-up form, you need to assign a macro or function to the forms "On Open" property that will do the maximize. -- +-------------------------------------------------------+ | Steve Miller PictureTel Corporation | | email: miller@pictel.com One Corporation Way | | phone: (508) 977-8235 Peabody, MA 01960 | +-------------------------------------------------------+ ========================================================================= Date: Wed, 1 Sep 1993 09:56:33 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Chet Farmer Organization: Project IDEALS -- The University of Alabama Subject: Re: Automatic field updates In-Reply-To: Message of Tue, 31 Aug 1993 11:21:40 GMT from On Tue, 31 Aug 1993 11:21:40 GMT Richard Saunders, Computer Centre said: >I believe you've had some replies about displaying these fields on >your form. What worries me a little bit is that you say you want to >place the data into the appropriate fields in the original table. The >whole idea of a relational database is that you DON'T duplicate data >in different tables. Regardless of the "whole idea of relational databases," what we want to do is automate data entry for the two fields in question. Period. It seems the simplest approach, and one that simplifies further work (ie, reports & such done later). Of course, if you have an easier way in mind to accomplish the same thing with a minimum of complexity, that's great. Please share it with us. It's kind of a "make the program do what we want" issue, not a "proper behavior in relational databases" one. +----------------------------------------------------------------+ | Chet Farmer, Assistant Director | tel 205-348-9494 | | Project IDEALS | cfarmer1@ua1vm.ua.edu | | The University of Alabama | chet.farmer@genie.geis.com | |----------------------------------------------------------------| | C is for Cookie, and that's good enough for me. -- C. M. | +----------------------------------------------------------------+ ========================================================================= Date: Wed, 1 Sep 1993 08:59:54 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Monty Kingsley <3533P@NAVPGS.BITNET> Subject: Retrieving Info from the DB on what-number row out of how many is displayed I'm a new developer in MSAccess which i think is a great product. But there are a couple of rather simple-minded things i'm trying to do which i haven't had any trouble with in other DB environments. Let me illustrate with an example: say you have a payroll table for employees. What you want to do is display on a single form salary payment info for an em- ployee which has been sorted in ascending order by time. B U T you also want to display info on how many such payments there are for the employee A N D the number (in the sequence order) for the payment info now displayed. Now, i confess i might be embarressed by a few two line replies showing how. I'm not completely stupid to the extent i can use a SQL count(*) query to display the total number of payments for an employee; even though i'm still having trouble getting this number to change when my form focuses on another employee. But with respect to showing which number is being displayed in the sequence, i haven't a clue, after tryinq queries with count(*), Dcount and a few other odds and ends. i called the Microsoft hotline and they just confirmed the difficulty of doing this, saying it's best done in Basic. Somehow this made me feel better! Well, any help wld sure be appreciated, despite how stupid it makes me look. Regards/ Monty ========================================================================= Date: Wed, 1 Sep 1993 14:01:08 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Scott Dahne Subject: hot keys? Does anyone know if there are hot keys for Access? ========================================================================= Date: Wed, 1 Sep 1993 14:35:11 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Scott Dahne Subject: comand buttons on reports You can put a command button on a report but the properties box doesn't include a field to attach an action to the button. Does anyone know how to attach a macro to a command button on a report? Scott Dahne Research Fellow Logistics Management Institute Bethesda, MD USA sdahne@lmi.org ========================================================================= Date: Wed, 1 Sep 1993 18:58:58 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Greg Fairnak Organization: The American University Subject: Suggestion for Monty Seeing as how you are not stupid I will not insult your intelligence by posting 2 lines of basic code :-)..... You might want to try REFRESH QUERY. Maybe hook it to a button. You could also attach a macro to the "focus" of the list box. In other words, when the user clicks on an employee a new salary payments and number come up. Also, form/ subform comes to mind. Good luck, Greg ========================================================================= Date: Thu, 2 Sep 1993 08:18:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Long Subject: "New Line"Code? I heard that there are four lines of code that can entered into the "before update" section of a memo field that will allow one to enter carriage returns "new lines" without advancing to the next field. Thanks ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Thu, 2 Sep 1993 10:09:06 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jeff Frost Subject: Multiple Changes Hi, I'm looking for a way to make changes to multiple fields on a report. For example, I have 15 text boxes that display numbers and I would like to select them all and make them the same size, format, etc.. Currently I'm selecting each individually and changing it. Is there a better way? Thanks, Jeff ========================================================================= Date: Thu, 2 Sep 1993 09:35:21 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Shannon Burgin <##06@UTMARTN.BITNET> Subject: references to controls, etc. Is there a method of identifying all of the places a fieldname, or for that matter filename, controlname, etc., are being used in an Access Database Application? Example: fieldname ABCD appears: Tablename xxxx Formname yyyy Formname zzzz Query wwww Macro mmmm ************************************************************************ * * * * Shannon Burgin * University of Tennessee/Martin * * Bitnet: ##06@UTMARTN.BITNET * Computer Center * * Phone: 901-587-7890 * 102 Cooper Hall * * Senior Systems Analyst * Martin, TN 38238 * * VM/VSE/CICS/VSAM/DLI/SQLDS * * ************************************************************************ ========================================================================= Date: Thu, 2 Sep 1993 09:59:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: mkro Subject: Printing from ACCESS BASIC Hello All! I am relatively new at "PC" programming, I been in the Mainframe environment. Can anyone show me or send me some SAMPLE ACCESS BASIC code that prints directly to LPT1 or LPT2, etc..? I need to be able to send printer escape sequences and control characters. I am trying to print AIRBORN airbill labels using data stored in ACCESS tables. Any help or point of reference would be greatly appreciated. Thanks in advance, Mike Kroeger Standard Disclaimer Applies +---------------------------------------------------------------------------- ------------------------------------------------------------------------+ + T E X A S I N S T R U M E N T S C O N S U M E R P R O D U C T S D I V I S I O N + +---------------------------------------------------------------------------- ------------------------------------------------------------------------+ + Phone: (214) 917-1591 Fax: (214) 917-1505 e-Mail: MKRO.DIS-PC@BMAILIN.ITG.TI.COM + +---------------------------------------------------------------------------- ------------------------------------------------------------------------+ *** uuencoded BINARY enclosure *** The section below this line contains an MHS attachment. To extract it, copy this message to a file and use the program UUDECODE. For information on using UUDECODE on UNIX systems, type the command 'man uudecode'. The attachment name was originally: ATTRIBS.BND --------------- begin 644 attribs.bnd M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``9O)FIK*```````4')I;G1I;F<@ M9G)O;2!!0T-%4U,@0D%324,````````````````````````````````````` M```````````````````````````````````````````````````````````` M`&UK'1\!$AE;&QO($%L;"$* M(`H@("!)(&%M(')E;&%T:79E;'D@;F5W(&%T(")00R(@<')O9W)A;6UI;F6]N92!S:&]W(&UE(`H@(&]R('-E;F0@;64@2!H M96QP(&]R('!O:6YT(&]F(')E9F5R96YC92!W;W5L9"!B92!G Organization: KING Systems Subject: Re: references to controls, etc. In-Reply-To: <9309021515.AA07226@rampage.psi.net> >DATE: Thu, 2 Sep 1993 09:35:21 EDT >FROM: Shannon Burgin <##06%UTMARTN.BITNET@uga.cc.uga.edu> > >Is there a method of identifying all of the places a fieldname, or for >that matter filename, controlname, etc., are being used in an Access >Database Application? I am fairly sure there is not. If there is, I would sure like to know about it. There are was to determine all those things, but not to cross reference them. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Thu, 2 Sep 1993 16:57:39 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: Multiple Changes In-Reply-To: <9309021515.AA07182@rampage.psi.net> >DATE: Thu, 2 Sep 1993 10:09:06 EST >FROM: Jeff Frost > > Hi, I'm looking for a way to make changes to multiple fields on a > report. For example, I have 15 text boxes that display numbers and I > would like to select them all and make them the same size, format, > etc.. Currently I'm selecting each individually and changing it. Is > there a better way? You can select them all easily enough. Either use the mouse to draw a box around them or hold down the shift key when you select them. It is nice for aligning controls and moving groups of them around. But there is no way to change a group of properties at once and change them. You could write code to to it in most cases, but it would likely take longer than changing them individually. It would be nice to be able to do it. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Thu, 2 Sep 1993 17:15:00 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: strange report print bug I have one report in a database that used to work fine. Suddenly it will print the first two pages fine, then start to choke on the third page and make a complete mess of the fourth page altogether. The kicker is that I can get pages three and four to print without a problem if I print them individually (i.e., print range 3 to 3 or 4 to 4). I'm printing to a HPLJ IIID in PCL mode (Postscript is worse!) that's hooked to my computer via a Buffalo SLmkII peripheral sharing device. Any thoughts? I think the report is corrupt somehow but even running Repair Database didn't help. I'd hate to re-do it from scratch but that's what I'm looking at. I do NOT have this problem with any other report. TIA, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 2 Sep 1993 18:19:12 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: cross references to controls, etc. From: "John M. King", INTERNET:p00756@PSILINK.COM % >FROM: Shannon Burgin <##06%UTMARTN.BITNET@uga.cc.uga.edu> % > % >Is there a method of identifying all of the places a fieldname, or for % >that matter filename, controlname, etc., are being used in an Access % >Database Application? % % I am fairly sure there is not. If there is, I would sure like to know % about it. There are was to determine all those things, but not to % cross reference them. I would suggest one look at how the Access Analyzer works -- if it doesn't do what you want, there are plenty of clues there for determining how to do your own. The big "trick" is knowing to go into the "View" option, select "Options", and change "Show System Objects" to "Yes". You'll see plenty of little interesting things show up in the container class window then... I have a (pedantic) cursiosity question: if you can determine the information, why can you not cross-reference it? One would think it would be like saying "I know what the batter did each time at the plate, but I can't figure out his batting average" -- wouldn't it? I'm not intending this as a flame, just trying to understand the reasoning. ========================================================================= Date: Thu, 2 Sep 1993 15:41:38 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jonathan Lavigne Subject: Re: Multiple Changes REPLY TO 09/02/93 14:30 FROM ACCESS-L@INDYCMS.BITNET "Microsoft Access Database Discussion List": Re: Multiple Changes >From: "John M. King" >Organization: KING Systems >Subject: Re: Multiple Changes >To: Multiple recipients of list ACCESS-L >In-Reply-To: <9309021515.AA07182@rampage.psi.net> > >>DATE: Thu, 2 Sep 1993 10:09:06 EST >>FROM: Jeff Frost >> >> Hi, I'm looking for a way to make changes to multiple fields on a >> report. For example, I have 15 text boxes that display numbers and I >> would like to select them all and make them the same size, format, >> etc.. Currently I'm selecting each individually and changing it. Is >> there a better way? > >You can select them all easily enough. Either use the mouse to draw a >box around them or hold down the shift key when you select them. It is >nice for aligning controls and moving groups of them around. But there >is no way to change a group of properties at once and change them. > >You could write code to to it in most cases, but it would likely take >longer than changing them individually. > >It would be nice to be able to do it. John, It's true that you can't change properties (such as Can Grow, Can Shrink, etc.) for a group of controls. At least, if you can do it, I don't know how. But Jeff's original post asked about resizing and reformatting multiple controls at the same time. I just discovered how to do that today, though I guess if I had bothered to look at all the menu options, I would have noticed much earlier. It would have saved me a lot of trouble fiddling around with command buttons to get them all the same size. Here's the proceudre. 1. In design view for a report (or a form), define the size, borders etc. for one control and select that control. 2. Choose Layout/Change Default to save the layout options for the selected control as the default. 3. Select the other controls to which you want to apply the default. 4. Choose Layout/Apply Default to apply the default characteristics to all the selected controls. Jonathan Lavigne Research Libraries Group/Stanford University To: ACCESS-L@INDYCMS.BITNET ========================================================================= Date: Fri, 3 Sep 1993 06:04:42 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: cross references to controls, etc. In-Reply-To: <9309022231.AA22811@rampage.psi.net> >DATE: Thu, 2 Sep 1993 18:19:12 EDT >FROM: Phil Paxton <72410.2162@COMPUSERVE.COM> > >From: "John M. King", INTERNET:p00756@PSILINK.COM >% >FROM: Shannon Burgin <##06%UTMARTN.BITNET@uga.cc.uga.edu> >% > >% >Is there a method of identifying all of the places a fieldname, or for >% >that matter filename, controlname, etc., are being used in an Access >% >Database Application? >% >% I am fairly sure there is not. If there is, I would sure like to know >% about it. There are was to determine all those things, but not to >% cross reference them. > > >I have a (pedantic) cursiosity question: if you can determine the information, > why can you not >cross-reference it? One would think it would be like saying "I know what the > batter did each time at the >plate, but I can't figure out his batting average" -- wouldn't it? I'm not > intending this as a flame, just trying to >understand the reasoning. The reasoning is this. It is easy, as you indicate, to use the analyzer to produce a report, for example, of field names and all the tables they are used in. It is an easy reportto produce and I have made good use of it. It is not as easy, and may not be possible, to produce a report showing everywhere in an application a given control or field is referenced--in macros, functions, etc. There is a product called "Total Access" which produces a vast amount of documentation. We are ordering it, but I have not used it yet. I believe that I read that it does not include such a cross reference. I would be very interested in seeing the details, if you have produced such a report. That was the main reason for my response. I do not believe it is a trivial task and would be interested in seeing how it is done. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Fri, 3 Sep 1993 09:50:23 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: strange report print bug In-Reply-To: Message of Thu, 2 Sep 1993 17:15:00 EST from On Thu, 2 Sep 1993 17:15:00 EST Nathan Brindle said: >I have one report in a database that used to work fine. Suddenly it will >print the first two pages fine, then start to choke on the third page >and make a complete mess of the fourth page altogether. The kicker is >that I can get pages three and four to print without a problem if I >print them individually (i.e., print range 3 to 3 or 4 to 4). I'm printing >to a HPLJ IIID in PCL mode (Postscript is worse!) that's hooked to my >computer via a Buffalo SLmkII peripheral sharing device. Any thoughts? >I think the report is corrupt somehow but even running Repair Database >didn't help. I'd hate to re-do it from scratch but that's what I'm >looking at. I've sort of had a very similar problem -- but the computer says "buffer full" and then you have to start all over. Have you checked using another printer, or a dump to disc (ascii would be best so you can check)? If there's no problem there, look at the computer. But waht you say below seems to indicated it might well be your report got glitched up (so to speak). Good luck, David >I do NOT have this problem with any other report. ========================================================================= Date: Fri, 3 Sep 1993 09:54:28 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: Multiple Changes In-Reply-To: Message of Thu, 2 Sep 1993 15:41:38 PDT from Thanks, Jonathan, for the multiple sizing tip. Terrific. Best, David ========================================================================= Date: Fri, 3 Sep 1993 10:12:39 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: cross references to controls, etc. In-Reply-To: Message of Fri, 3 Sep 1993 06:04:42 -0400 from Please would you provide complete information on Total Access -- esp. an 800 number. Many thanks, David ========================================================================= Date: Fri, 3 Sep 1993 10:06:03 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: strange report print bug In-Reply-To: Message of Fri, 3 Sep 1993 09:50:23 CDT from David, I don't have a buffer problem because I don't use the &#^#! print manager. I need stuff faster than the PM can give it to me. But it is possible that it is the printer (and it also have something to do with the context-sensitive printer language switcher that runs as a TSR and determines whether the document is PS or PCL and informs the printer accordingly. I'll do some checking and report what I find back to the list. BTW, MS was supposed to be marketing some super-duper print accellerator some time back. Did anyone ever see it? There was a splash in one of the slick magazine/ads I got in the mail but no ordering information and then it seemed to disappear. Then I heard something about a lawsuit. ??? Thanks, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 3 Sep 1993 08:25:57 MST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Dan Eklund Subject: Re[2]: cross references to controls, etc. Please would you provide complete information on Total Access -- esp. an 800 number. Many thanks, David From Aug/Sep 93 ACCESS ADVISOR Mag page 9 Special Intro Price $145 + $5 S&H FMS, Inc. 8027 Leesburg Pike, Suite 410 Vienna, VA 22182 (703) 356-4700, FAX: (703) 448-3861 Good Luck Dan ========================================================================= Date: Fri, 3 Sep 1993 11:50:02 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: strange report print bug In-Reply-To: Message of Fri, 3 Sep 1993 10:06:03 EST from Thanks, Nathan. Your problem seems too complex for me. Good luck -- would like to know how you solve it. Best, david ========================================================================= Date: Fri, 3 Sep 1993 11:57:38 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jon Diercks Subject: Re: strange report print bug In-Reply-To: from "Nathan Brindle" at Sep 2, 93 5:15 pm > ...to a HPLJ IIID in PCL mode (Postscript is worse!) that's hooked to my > computer via a Buffalo SLmkII peripheral sharing device. Any thoughts? If either of the buffalo connections (PC<->buf or buf<->printer) are serial, make sure you have flow control set up correctly on both sides. We set the buffalo for both hardware and software flow control. -- \on \ jon@anderson.edu Administrative Systems \_\ <_\iercks Anderson University > Anderson, IN --- ...Life is too important to be taken seriously. ========================================================================= Date: Fri, 3 Sep 1993 12:15:06 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: strange report print bug In-Reply-To: Message of Fri, 3 Sep 1993 11:57:38 EST from Thanks, Jon, I'll check that. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 3 Sep 1993 15:02:47 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Total Access % From: Dan Eklund, INTERNET:eklundd@NOAO.EDU % From Aug/Sep 93 ACCESS ADVISOR Mag page 9 % Special Intro Price $145 + $5 S&H *snicker* it's always funny to see supporting products costing more than the product itself! ========================================================================= Date: Fri, 3 Sep 1993 09:29:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Long Subject: Counter Number I'm trying to set a field with a data type of counter, to start with a specified number. My problem is that I have two separate databases being inputed with like information. When I go to append the data from one to the other then I have clashing record numbers. Is it possible to get around this problem? Any information would be appreciated. ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Fri, 3 Sep 1993 16:59:26 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Merging "Unique" Counter Numbers / was Counter Numbers % From: David Long % I'm trying to set a field with a data type of counter, to % start with a specified number. My problem is that I have % two separate databases being inputed with like information. % When I go to append the data from one to the other then I have % clashing record numbers. Is it possible to get around this % problem? Any information would be appreciated. A similar problem was posed on this list recently. The request was for unique values to be established such [that] a merged set of tables would ensure the primary key would remain unique. My suggestions (the latter is probably better) with a twist for your situation are: 1) Assign a unique identifier to each PC and use it as part of the primary key with a counter field. But this means monitoring and maintaining extra information. 2) Make the primary key a combination of a counter field and the entry time. When you merge/append the individual tables into the master table, the counter field of the "real" table could be used rather than the one assigned at the individual machines. Hope this helps. ========================================================================= Date: Fri, 3 Sep 1993 17:00:24 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Chet Farmer Organization: Project IDEALS -- The University of Alabama Subject: Re: Automatic field updates In-Reply-To: Message of Tue, 31 Aug 1993 09:32:12 +0200 from On Tue, 31 Aug 1993 09:32:12 +0200 Stefan Focke said: >>I've experimented with the DLookUp function to a point; I've even managed >>to get a non-interactive version of this working for the French name (ie, >>I've an action query that runs through the database and supplies the >>French name for every record). What I want still eludes me. > >DLookUp should work for you. I did something simular and it worked. Prehaps >you should post the code you use. Thanks, Stefan -- if I can't get it to go after a good try, I'll post some code. Have a good weekend -- actually, at this writing, it appears you're probably already having one, time zones being what they are. >Stefan Focke Tel. 02241-14-3154 >GMD-ISA e-mail: focke@gmd.de >Rathausalle 10 >D-W 5205 Sankt Augustin 1 > ********** MS-Word: From the guys who brought us EDLIN ******** There are those who claim that EDLIN is MS-DOS' only real claim to being a "real" operating system -- the basis being that all "real" operating systems come with an impossible-to-use, user-hostile, irritating editor. See Unix (vi), VM/XA (Xedit), etc. +----------------------------------------------------------------+ | Chet Farmer, Assistant Director | tel 205-348-9494 | | Project IDEALS | cfarmer1@ua1vm.ua.edu | | The University of Alabama | chet.farmer@genie.geis.com | |----------------------------------------------------------------| | C is for Cookie, and that's good enough for me. -- C. M. | +----------------------------------------------------------------+ ========================================================================= Date: Fri, 3 Sep 1993 17:03:36 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: cross references to controls, etc. In-Reply-To: <9309031512.AA13990@rampage.psi.net> >DATE: Fri, 3 Sep 1993 10:12:39 CDT >FROM: David Crookall > >Please would you provide complete information on >Total Access -- esp. an 800 number. Many thanks, David Total Access is a product of FMS, Inc 8027 Leesburg Pike Suite 410, Dept. 322 Vienna, VA 22182 703-356-4700 ext 322 703-448-3861 (fax) Compuserve 73710,463 also 75160,3375 no 800 # given Add says includes a "Field Cross-Reference" as one of 40 built-in reports. I have not used the product. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Fri, 3 Sep 1993 14:33:00 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Miguel Rivera Subject: Help with lots of records in Combo Box Hi everybody, My brother is developing an application using access and he ran into a performance problem. Here is the problem: The system he is developing is a Point of Sale system. There are basically 3 tables involved in this problem. The first table is called "Products" and this table holds all the products available in the store keyed by BarCode. The second table is the "Inventory" table which holds the inventory information keyed by BarCode. Some of the inventory information are lot number, expiration date, and so on. The relationship between "Products" and "Inventory" is a one to many relationship. Ok so far, the third table has the actual sale information which holds information about who bought the product, how much was paid for it, and so on. The sale form is a continuous form with the following fields: BarCode Units PricePerUnit Total (Calculated field) QtyOnInventory (Calculated field) The BarCode field is a ComboBox and it is using a Query as a source. The Query generates a table with the following fields: ProductDescription BarCode The bounded field in the combo box is the BarCode, but the user choose the product by the description. Now, here is the problem. First the combo box shows only the items on inventory using the UNIQUE option of the query. This means that the number of items in the combo box is less or equal to the number of items in the "Products" table. The problem is that the product table has over 8000 records and Access become very slow handling the combo box to the point that become unusable running on a 386 33MGZ with 8 Megs of RAM and 12ms HD. I like his design because it is easy to use for the salesperson but it is trading off performance. Does anybody has a suggestion on how to balance the performance with the usability of the program? Any reply is greatly appreciated. Thank you, Miguel Rivera miguelr@ihlpe.att.com ========================================================================= Date: Fri, 3 Sep 1993 21:35:57 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phillip Paxton <72410.2162@COMPUSERVE.COM> Subject: Help with lots of records in Combo Box % From: Miguel Rivera, INTERNET:miguelr@IHLPE.ATT.COM % My brother is developing an application using access and he ran into % a performance problem. Here is the problem: % Now, here is the problem. First the combo box shows only the items on inventory % using the UNIQUE option of the query. This means that the number of items % in the combo box is less or equal to the number of items in the "Products" % table. The problem is that the product table has over 8000 records and Access % become very slow handling the combo box to the point that become unusable % running on a 386 33MGZ with 8 Megs of RAM and 12ms HD. % I like his design because it is easy to use for the salesperson but % it is trading off performance. Does anybody has a suggestion on % how to balance the performance with the usability of the program? In a nutshell, the problem isn't in the design or in the hardware capacity (you'd probably see similar numbers on a 486). The problem is in overloading (not C++ overloading) your combo box. Access Combo Boxes are not built for allowing you to select every word in a dictionary. In terms of performance, those combo boxes are like spoons -- nice to eat soup with, but not to be used in place of a bucket or a bilge pump. Compu$erve is littered with many, many stories of people who design elegant applications only to see them wither away in support with their users once the database accumulates enough records to bog down the combo box. Perhaps a slight change would help -- I modified (actually, rewrote) the address book portion of the PIM which is supplied with Access and instead of the push buttons for A-Z taking you to a name immediately, it begins spelling out the name (you could substitute the keyboard) until you hit the ! (go) button and then use a combo box to select from the list of hits. Phil Paxton Development, Eidetic, and 7-ball juggler SAMS/Prentice Hall Computer Publishing Carmel, Indiana ========================================================================= Date: Sat, 4 Sep 1993 08:45:29 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: Counter Number In-Reply-To: <9309032026.AA24729@rampage.psi.net> >DATE: Fri, 3 Sep 1993 09:29:00 EDT >FROM: David Long > >I'm trying to set a field with a data type of counter, to >start with a specified number. My problem is that I have >two separate databases being inputed with like information. >When I go to append the data from one to the other then I have >clashing record numbers. Is it possible to get around this >problem? Any information would be appreciated. > It is possible to seed a table using a counter key, so that it starts at a particular number. You need a second table which has a long number field with the same name as the counter field of the first table, that would be the only field in the second table. Enter a value in the second table's field which is one less than the first key value you desire. Append the row from the second table to you first table. You can delete that row immediatlely afterward. Rows added to your first table will have a key one greater than the "seeded" row. Do not compact the table before adding the first row of "real" data or the counter will be reset to 1. This technique come from the Microsoft Knowledge Base article # Q94821. You can adopt varriations on this technique. The key is that you can append rows to a table with whatever key value you want to seed you tables. I don't know if this fits your situation, but I hope it is of some use. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Sat, 4 Sep 1993 10:44:23 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phillip Paxton <72410.2162@COMPUSERVE.COM> Subject: Re: Counter Number % From: "John M. King", INTERNET:p00756@PSILINK.COM > >I'm trying to set a field with a data type of counter, to >start with a specified number. My problem is that I have >two separate databases being inputed with like information. >When I go to append the data from one to the other then I have >clashing record numbers. Is it possible to get around this >problem? Any information would be appreciated. > % It is possible to seed a table using a counter key, so that it starts % at a particular number. You need a second table which has a long % number field with the same name as the counter field of the first % table, that would be the only field in the second table. Enter a value % in the second table's field which is one less than the first key value % you desire. % I don't know if this fits your situation, but I hope it is of some use. Based upon the original premise, I'm not sure how this fits in -- for multiple collection sites, it would seem to cause extra overhead in the merging process since the data would have to be preprocessed. ========================================================================= Date: Sat, 4 Sep 1993 13:29:32 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: Total Access In-Reply-To: Message of Fri, 3 Sep 1993 15:02:47 EDT from <72410.2162@COMPUSERVE.COM> On Fri, 3 Sep 1993 15:02:47 EDT Phil Paxton said: >% From: Dan Eklund, INTERNET:eklundd@NOAO.EDU >% From Aug/Sep 93 ACCESS ADVISOR Mag page 9 >% Special Intro Price $145 + $5 S&H > >*snicker* it's always funny to see supporting products costing more than the > product itself! Could some of you please let us know what Total Access is like. Is it worth it? (even if it's more than Access itself). Does it actually help one a lot to build efficient data bases? Thanks, David ========================================================================= Date: Sat, 4 Sep 1993 13:33:31 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: cross references to controls, etc. In-Reply-To: Message of Fri, 3 Sep 1993 17:03:36 -0400 from Thanks, John, for the info. Do you think that Total Access is worth the money? Does it help a lot in developing a db? Could people out there let us know what they think of Total Access. Thanks, David. John, do you market any products that help with developing databases? Best, David ========================================================================= Date: Sat, 4 Sep 1993 14:01:04 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: field: date_last_modified: how to do it? I wonder if any of you can tell me how to do the following: I have a date field in my data-base which defaults to the current date on data entry to the record. I would like to have ANOTHER field which automatically updates to the current date every time the record is modified (not simply looked at). Initially, both field will contgain the same date, but when the record is modified, the "entry date" will remain and the "date last modified" will change. I hope that is clear. Is this complicated? Thanks, David ========================================================================= Date: Sat, 4 Sep 1993 14:07:29 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: one report / several queries I have another problem. Is there any way one can have reports separate from quesries? Let me try to explain. I have a report which outputs data in a specified way to the printer. I would like to be able to tell it to output only subsets of all the data. For example, instead of printout out all the addresses, I would like to print out address in Germany, or Germany and France, or in Germany and entered after 15 Aug 93, or ... . In other words, can a have a set of queries separate from a report? Or, can I use different queries for the same report? And more importantly !, how does one do that? Or am I asking a rediculously simple question? And if I am, I'd still like to know. Many thanks for any help you can provide. Best wishes, David ========================================================================= Date: Sat, 4 Sep 1993 14:01:29 -0700 Reply-To: robert@slipknot.rain.com Sender: Microsoft Access Database Discussion List From: Robert Reed Subject: Re: one report / several queries In-Reply-To: Your message of Sat, 04 Sep 93 14:07:29 -0500. David Crookall writes: | I have another problem. Is there any way one can have reports | separate from quesries? Let me try to explain. I have a report | which outputs data in a specified way to the printer. I would | like to be able to tell it to output only subsets of all the data. | For example, instead of printout out all the addresses, I would | like to print out address in Germany, or Germany and France, ... Simple. Build your report from a derived table (i.e., one that only contains data derived from other tables). Then use your various queries to fill that table and print it as a report. It's real simple to create a macro to delete the current contents of the derived table, append new records, and run the report. That's how I turn our address database into personalized printed phonebooks, either for my wife or me. ________________________________________________________________________________ Robert Reed Home Animation Ltd. 503-656-8414 home: robert@slipknot.rain.com 5686 First Court, West Linn, OR 97068 work: robert@metheus.com 503-690-1550 Your kids are going to do to you exactly what you did to your parents. I know my son is going to do this to me. Sixteen years from now, he's going to walk up to me and say, "God, Dad, you're fucked!" And my father will be standing right behind him going, "Yeaaayes! Ahahaha, revenge is Mine!" And you have dreams that one day your kid will be standing up there going, "I'd like to thank the Nobel Academy." But you have this other dream he'll be saying, "You want fries with this?" --Robin Williams ________________________________________________________________________________ ========================================================================= Date: Sat, 4 Sep 1993 18:28:43 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: Counter Number In-Reply-To: <9309041447.AA12564@rampage.psi.net> >DATE: Sat, 4 Sep 1993 10:44:23 EDT >FROM: Phillip Paxton <72410.2162@COMPUSERVE.COM> > >% From: "John M. King", INTERNET:p00756@PSILINK.COM >> >>I'm trying to set a field with a data type of counter, to >>start with a specified number. My problem is that I have >>two separate databases being inputed with like information. >>When I go to append the data from one to the other then I have >>clashing record numbers. Is it possible to get around this >>problem? Any information would be appreciated. >> > >% It is possible to seed a table using a counter key, so that it starts >% at a particular number. You need a second table which has a long >% number field with the same name as the counter field of the first >% table, that would be the only field in the second table. Enter a value >% in the second table's field which is one less than the first key value >% you desire. > >% I don't know if this fits your situation, but I hope it is of some use. >- >Based upon the original premise, I'm not sure how this fits in -- for multiple >collection sites, it would seem to cause extra overhead in the merging process >since the data would have to be preprocessed. It may in practice not fit in at all. It might, however, fit in this way. One of the tables would be initialized with a starting counter number relatively high, e.g., 50000, or whatever. The other table would start with 1. This would prevent the clash of counter numbers. The "overhead" is minimal. The extra processing is only done once, when the table is initialized. It, or some variation of it, appears to be the only way to start a counter field at some particular value. Please let me know, if there is another way. One can, of course, use a multi-field key, as was suggested, with some indicator to distinguish the tables or something else. The technique I described may not be the preferable one in this situation. But, it does seem to "fit in" as it answered a part of the original request--namely how to start a counter field with a specific number. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Sat, 4 Sep 1993 18:40:39 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: cross references to controls, etc. In-Reply-To: <9309041834.AA15641@rampage.psi.net> >DATE: Sat, 4 Sep 1993 13:33:31 CDT >FROM: David Crookall > >Thanks, John, for the info. Do you think that Total Access >is worth the money? Does it help a lot in developing a >db? Could people out there let us know what they think >of Total Access. Thanks, David. > >John, do you market any products that help with developing >databases? Best, David You are welcome. I don't know if Total Access is worth the money or not. We are planning on getting it, but have not done so yet. I have seen one or two magazine reviews which were favorable, but they usually are. I can say that documentation is an area where MS Access is somewhat weak. This is particularly true with macros. I don't market any products to help in database development. I am currently involved in the development of an application using MS Access which may be marketed. Good Luck. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Sat, 4 Sep 1993 18:54:17 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: field: date_last_modified: how to do it? In-Reply-To: <9309041904.AA16165@rampage.psi.net> >DATE: Sat, 4 Sep 1993 14:01:04 CDT >FROM: David Crookall > >I wonder if any of you can tell me how to do the following: >I have a date field in my data-base which defaults to the >current date on data entry to the record. I would like >to have ANOTHER field which automatically updates to the >current date every time the record is modified (not simply >looked at). Initially, both field will contgain the same >date, but when the record is modified, the "entry date" >will remain and the "date last modified" will change. >I hope that is clear. Is this complicated? >Thanks, David David, It can be done using Access Basic code. Bound controls on forms have a property called OldValue. You can write a function to cycle through the controls on a form and determine if any have changed. You would then write a new date to the field "date last modified." This is only useful if you are using a form to update your records. I don't think there is a record level property to tell if a record has changed. If this is of use, I can post a copy of a function to determine if a record has changed. I got it from Compuserve. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Sun, 5 Sep 1993 09:35:23 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: field: date_last_modified: how to do it? In-Reply-To: Message of Sat, 4 Sep 1993 18:54:17 -0400 from Thanks, John, I'm not sure if we are talking about exactly the same thing, so let me respond to your very helpful reply. On Sat, 4 Sep 1993 18:54:17 -0400 John M. King said: >>DATE: Sat, 4 Sep 1993 14:01:04 CDT >>FROM: David Crookall >>I have a date field in my data-base which defaults to the >>current date on data entry to the record. I would like >>to have ANOTHER field which automatically updates to the >>current date every time the record is modified (not simply >>looked at). Initially, both field will contgain the same >>date, but when the record is modified, the "entry date" >>will remain and the "date last modified" will change. >It can be done using Access Basic code. Bound controls on forms have a >property called OldValue. You can write a function to cycle through >the controls on a form and determine if any have changed. You would >then write a new date to the field "date last modified." This is only >useful if you are using a form to update your records. Yes, I will be using a form to update records. >I don't think there is a record level property to tell if a record >has changed. If this is of use, I can post a copy of a function to >determine if a record has changed. I got it from Compuserve. That would be very useful. Thanks. Is there a useful area in Compuserve devoted to Access? Is it worth joining for that? The problem I still don't know how to deal with is to have the current date (today) automatically enter itself into the "date last modified" field. I was thinking that there might be some function that would do this automatically if one of the other fields had been modified. Presumably this would happen as one moved to another record or closed the file (ie moved away from the current record). Would the cursor actually have to move "through" the field for anything to happen? The best would be to have the field update simply if some other field had been changed. I'm learning! Also learning the limitations of Access (is that unfair?). Thanks again for all your help. Best, David. ========================================================================= Date: Sun, 5 Sep 1993 15:05:33 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: ACC-KB on CICA The ACC-KB has been moved to the /pub/pc/win3/access directory on FTP.CICA.INDIANA.EDU. The problem is that they renamed it during the move and it looks like a plain .ZIP file. I have notified the CICA administrators and hope they'll do something about it. In the meantime, should you ftp ACC-KB.ZIP from CICA, rename it to ACC-KB.EXE and run it from the DOS prompt. You will not be able to unzip it with PKUNZIP 1.10 because I archived it with 2.04g. That's why it was put on CICA as a self-dissolving archive. BTW, this is NOT a new version of the ACC-KB. It's still the February 1993 copy. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Mon, 6 Sep 1993 10:33:16 GMT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Richard Saunders, Computer Centre" Organization: University Of East London Subject: Re: Automatic field updates > On Tue, 31 Aug 1993 11:21:40 GMT Richard Saunders, Computer Centre said: > >I believe you've had some replies about displaying these fields on > >your form. What worries me a little bit is that you say you want to > >place the data into the appropriate fields in the original table. The > >whole idea of a relational database is that you DON'T duplicate data > >in different tables. > > Regardless of the "whole idea of relational databases," what we want > to do is automate data entry for the two fields in question. Period. > It seems the simplest approach, and one that simplifies further work > (ie, reports & such done later). > > Of course, if you have an easier way in mind to accomplish the same > thing with a minimum of complexity, that's great. Please share it with > us. > > It's kind of a "make the program do what we want" issue, not a "proper > behavior in relational databases" one. Ouch! I should have phrased my reply a little differently to make it clear that I'm still a beginner where databases and Access are concerned. As such I doubt if I can improve on anything you've come up with, so I'll leave it to the experts. ========================================================================= Date: Mon, 6 Sep 1993 07:52:20 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: field: date_last_modified: how to do it? In-Reply-To: <9309060254.AA06159@rampage.psi.net> >DATE: Sun, 5 Sep 1993 09:35:23 CDT >FROM: David Crookall > [ much deleted to save space] > >>I don't think there is a record level property to tell if a record >>has changed. If this is of use, I can post a copy of a function to >>determine if a record has changed. I got it from Compuserve. > >That would be very useful. Thanks. Is there a useful area in >Compuserve devoted to Access? Is it worth joining for that? > >The problem I still don't know how to deal with is to have the current >date (today) automatically enter itself into the "date last modified" >field. I was thinking that there might be some function that would >do this automatically if one of the other fields had been modified. >Presumably this would happen as one moved to another record or closed >the file (ie moved away from the current record). Would the cursor >actually have to move "through" the field for anything to happen? The >best would be to have the field update simply if some other field >had been changed. > >I'm learning! Also learning the limitations of Access (is that unfair?). >Thanks again for all your help. Best, David. Here is the function: -------------------------------------------------------------------------- Function IsRecordChanged (F As Form) Dim i As Integer Dim Changed As Integer Dim temp As Integer 'Handle non-bound controls On Error GoTo RIC_Err Changed = False For i = 0 To F.Count - 1 ' Reset the error trapper first Err = 0 temp = False If (IsNull(F(i)) Or IsNull(F(i).OldValue)) Then temp = temp Or (IsNull(F(i).OldValue) And Not IsNull(F(i))) temp = temp Or (IsNull(F(i)) And Not IsNull(F(i).OldValue)) Else temp = (F(i) <> F(i).OldValue) End If If Err = 0 Then Changed = Changed Or temp End If LoopBottom Next i ISRecordChanged = Changed Exit Function RIC_Err: Resume LoopBottom End Function ----------------------------------------------------------------------- Credit for this belongs to Ken Getz 76137,3650. Any obvious errors are likely due to my lack of typing skills. I have not used the function. I would think you would put it in the OnClose property of the form, with modifications to update the "last update" field in the table if the record changed. If you put it in the field itself, it would not get executed unless you "moved" through the field. In any case, it will not all be automatic until you code it that way. I can't really say if it will be worth it to you to join CompuServe or not? If you use one of the automated aids to accessing it the costis not too high, but it is not free. The MSACCESS forum is very active and is supported by Microsoft and by very knowledgeable users. You can get official answers there. Try it, you can always stop. Cost is on a connect time basis primarily. Hope this helps. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Mon, 6 Sep 1993 12:07:53 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: ACC-KB on CICA In-Reply-To: Message of Sun, 5 Sep 1993 15:05:33 EST from Thanks, Nathan, for the info about the file. Best, David ========================================================================= Date: Mon, 6 Sep 1993 12:17:10 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: field: date_last_modified: how to do it? In-Reply-To: Message of Mon, 6 Sep 1993 07:52:20 -0400 from Many thinks indeed to John King for your help. Best, David ========================================================================= Date: Mon, 6 Sep 1993 12:46:34 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Chet Farmer Organization: Project IDEALS -- The University of Alabama Subject: Re: Automatic field updates In-Reply-To: Message of Mon, 6 Sep 1993 10:33:16 GMT from On Mon, 6 Sep 1993 10:33:16 GMT Richard Saunders, Computer Centre said: >Ouch! I should have phrased my reply a little differently to >make it clear that I'm still a beginner where databases and Access >are concerned. As such I doubt if I can improve on anything you've >come up with, so I'll leave it to the experts. Not a problem -- in retrospect, I may have fired my reply a bit hastily, so we'll chalk it up to experience. Thanks for your help, at any rate. We're all beginners at my end! +----------------------------------------------------------------+ | Chet Farmer, Assistant Director | tel 205-348-9494 | | Project IDEALS | cfarmer1@ua1vm.ua.edu | | The University of Alabama | chet.farmer@genie.geis.com | |----------------------------------------------------------------| | C is for Cookie, and that's good enough for me. -- C. M. | +----------------------------------------------------------------+ ========================================================================= Date: Mon, 6 Sep 1993 10:31:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: RH Subject: "New line"Code? I heard that there are four lines of code that can entered into the "before update" section of a memo field that will allow one to enter carriage returns "new lines" without advancing to the next field. Thanks ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== The following extract from Microsoft's Technet CD ROM should provide an answer to your question: --------------------------------------------------------------------- Text boxes in Microsoft Access do not support using the ENTER key to add lines within a field. When ENTER is pressed in a text box, the focus is placed on the next field or control. This article explains how to change the functionality of pressing ENTER in text boxes so that it adds lines instead of changing the focus. The following function changes the behavior of the ENTER key in text boxes to allow adding lines instead of changing the focus to a different field or control. This code should be attached to the BeforeUpdate event of the text box. NOTE: There must be some change to the text box before this code will work because Microsoft Access evaluates controls only after they have been changed (dirtied). In the Declarations section of a Module, type the following: Declare Function GetKeyState% Lib "user.exe" (ByVal nKey%) Const VK_RETURN = &HD The following is the actual code: Function MakeEnterWork() If GetKeyState(VK_RETURN) < 0 Then DoCmd CancelEvent SendKeys "^{ENTER}" End If End Function Regards, Bob Hanschke Texas Instruments, Inc. Dallas, TX ========================================================================= Date: Tue, 7 Sep 1993 09:37:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: mkro Subject: RSCode39 Font for ACCESS Does anyone know where I could FTP a copy of the TrueType font called RSCode39? This is a bar code font for use with windows. Regards, Mike Kroeger *** uuencoded BINARY enclosure *** The section below this line contains an MHS attachment. To extract it, copy this message to a file and use the program UUDECODE. For information on using UUDECODE on UNIX systems, type the command 'man uudecode'. The attachment name was originally: ATTRIBS.BND --------------- begin 644 attribs.bnd M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``8G)6IK*```````4E-#;V1E,SD@ M1F]N="!F;W(@04-#15-3```````````````````````````````````````` M```````````````````````````````````````````````````````````` M`&UK'25`$1O97,@86YY;VYE M(&MN;W<@=VAE Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: macro documentation % I can say that documentation is an area where MS Access is somewhat % weak. This is particularly true with macros. % I don't market any products to help in database development. I am % currently involved in the development of an application using MS Access % which may be marketed. With the previous paragraph in mind, why focus on macros for a marketed product? Since you can't perform error-trapping in macros, it would be a death wish to rely upon them... (unless you are converting macros to ABC and working from there) ========================================================================= Date: Tue, 7 Sep 1993 09:06:17 PST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jim Richardson Subject: Re: "New Line"Code? There is a much simpler way of doing what you want. Just hold down the key then hit this will move the cursor to the Next Line. ************************************************************************ * James Richardson * Normal Disclaimer * * - Tech Extraordinary ;} US * My opinions belong to my Left Brain * * Canon Information Systems S * Those of my Right Brain might differ * * 4009 Miranda Avenue N * CIS can speak for itself * * Palo Alto CA 94304 A ***************************************** * 415-852-2090 VOICE I * RICHARDSON@CANON.COM -- EMAIL * * 415-852-2070 FAX L * WTMR52B -- PRODIGY * ************************************************************************ ______________________________ Reply Separator _________________________________ Subject: "New Line"Code? Author: mvdbl@MVGPG.ATT.COM at cis-ccsmtp Date: 9/2/93 8:18 AM I heard that there are four lines of code that can entered into the "before update" section of a memo field that will allow one to enter carriage returns "new lines" without advancing to the next field. Thanks ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Tue, 7 Sep 1993 11:08:00 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Miguel Rivera Subject: Bar Code Reader Does anybody have any recomendation for a Bar Code reader to use with windows and Access 1.1? Any infomation is greatly appreciated. Thank you, Miguel Rivera miguelr@ihlpe.att.com ========================================================================= Date: Tue, 7 Sep 1993 11:01:03 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jim Renaud Subject: Re: "New Line"Code? I needed this function too. Although I know about the combination (and use it), it is much harder to re-train users that are used to using Enter, alone. > > There is a much simpler way of doing what you want. Just hold down the > key then hit this will move the cursor to the Next Line. > > ************************************************************************ > * James Richardson * Normal Disclaimer * > * - Tech Extraordinary ;} US * My opinions belong to my Left Brain * > * Canon Information Systems S * Those of my Right Brain might differ * > * 4009 Miranda Avenue N * CIS can speak for itself * > * Palo Alto CA 94304 A ***************************************** > * 415-852-2090 VOICE I * RICHARDSON@CANON.COM -- EMAIL * > * 415-852-2070 FAX L * WTMR52B -- PRODIGY * > ************************************************************************ > > > ______________________________ Reply Separator _______________________________ __ > Subject: "New Line"Code? > Author: mvdbl@MVGPG.ATT.COM at cis-ccsmtp > Date: 9/2/93 8:18 AM > > > I heard that there are four lines of code > that can entered into the "before update" > section of a memo field that will allow > one to enter carriage returns "new lines" > without advancing to the next field. > Thanks > ============================================================================== > David B. Long E-Mail=> mvdbl@mvgpg.att.com > AT&T Network Systems or=> d.b-long@channel1.com > Quality Engineering Tele=> 508-960-3683 > ============================================================================== > ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Tue, 7 Sep 1993 11:06:55 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jim Renaud Subject: Re: Bar Code Reader There are lots available these days. I know of some from Worthington that works well. They supply laser and wand readers. Nowadays they interface between the keyboard and computer so that you see the code as though the user typed it in themself. If you can afford the hand-laser, I would get it. It is much more accurate than the wands. You can also scan at a distance with the hand-lasers. > > Does anybody have any recomendation for a Bar Code reader > to use with windows and Access 1.1? > > Any infomation is greatly appreciated. > > Thank you, > > Miguel Rivera > miguelr@ihlpe.att.com > ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Tue, 7 Sep 1993 13:46:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Long Subject: Counter Number >>I'm trying to set a field with a data type of counter, to >>start with a specified number. My problem is that I have >>two separate databases being inputed with like information. >>When I go to append the data from one to the other then I have >>clashing record numbers. Is it possible to get around this >>problem? Any information would be appreciated. >> >% It is possible to seed a table using a counter key, so that it starts >% at a particular number. You need a second table which has a long >% number field with the same name as the counter field of the first >% table, that would be the only field in the second table. Enter a value >% in the second table's field which is one less than the first key value >% you desire. Thanks John, this works just fine! It's to bad one has to "seed" the table by importing another...should be able to specify the starting number in the begining.....maybe in some future version. ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Tue, 7 Sep 1993 13:56:51 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Shannon Burgin <##06@UTMARTN.BITNET> Subject: Re: field: date_last_modified: how to do it? In-Reply-To: In reply to your message of SUN 05 SEP 1993 10:35:23 EDT > Thanks, John, I'm not sure if we are talking about > exactly the same thing, so let me respond to your > very helpful reply. > > On Sat, 4 Sep 1993 18:54:17 -0400 John M. King said: > >>DATE: Sat, 4 Sep 1993 14:01:04 CDT > >>FROM: David Crookall > > >>I have a date field in my data-base which defaults to the > >>current date on data entry to the record. I would like > >>to have ANOTHER field which automatically updates to the > >>current date every time the record is modified (not simply > >>looked at). Initially, both field will contgain the same > >>date, but when the record is modified, the "entry date" > >>will remain and the "date last modified" will change. > > >It can be done using Access Basic code. Bound controls on forms have a > >property called OldValue. You can write a function to cycle through > >the controls on a form and determine if any have changed. You would > >then write a new date to the field "date last modified." This is only > >useful if you are using a form to update your records. > > Yes, I will be using a form to update records. > > >I don't think there is a record level property to tell if a record > >has changed. If this is of use, I can post a copy of a function to > >determine if a record has changed. I got it from Compuserve. > > That would be very useful. Thanks. Is there a useful area in > Compuserve devoted to Access? Is it worth joining for that? > > The problem I still don't know how to deal with is to have the current > date (today) automatically enter itself into the "date last modified" > field. I was thinking that there might be some function that would > do this automatically if one of the other fields had been modified. > Presumably this would happen as one moved to another record or closed > the file (ie moved away from the current record). Would the cursor > actually have to move "through" the field for anything to happen? The > best would be to have the field update simply if some other field > had been changed. > > I'm learning! Also learning the limitations of Access (is that unfair?). > Thanks again for all your help. Best, David. If you are using a form, you can just modify the form's before update properties box to call a macro that does a set value on the field that you want to update. This will only update the updated date, if the record is being modified. ************************************************************************ * * * * Shannon Burgin * University of Tennessee/Martin * * Bitnet: ##06@UTMARTN.BITNET * Computer Center * * Phone: 901-587-7890 * 102 Cooper Hall * * Senior Systems Analyst * Martin, TN 38238 * * VM/VSE/CICS/VSAM/DLI/SQLDS * * ************************************************************************ ========================================================================= Date: Tue, 7 Sep 1993 14:54:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Long Subject: Re: "New Line"Code? I heard that there are four lines of code that can entered into the "before update" section of a memo field that will allow one to enter carriage returns "new lines" without advancing to the next field. Thanks ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== > > There is a much simpler way of doing what you want. Just hold down the > key then hit this will move the cursor to the Next Line. > Thanks Jim, sometimes the simplest solutions are the hardest to find. I'll try the code also, and ask my users what they prefer. ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Tue, 7 Sep 1993 17:36:56 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "John M. King" Organization: KING Systems Subject: Re: macro documentation In-Reply-To: <9309071525.AA10506@rampage.psi.net> >DATE: Tue, 7 Sep 1993 11:16:38 EDT >FROM: Phil Paxton <72410.2162@COMPUSERVE.COM> > >% I can say that documentation is an area where MS Access is somewhat >% weak. This is particularly true with macros. > >% I don't market any products to help in database development. I am >% currently involved in the development of an application using MS Access >% which may be marketed. > >With the previous paragraph in mind, why focus on macros for a marketed product ? > Since >you can't perform error-trapping in macros, it would be a death wish to rely > upon them... >(unless you are converting macros to ABC and working from there) A good point. Actually, my role does involve converting macros to code. I don't believe, however, that you can avoid them completely. You cannot do menus in code, macros seem to be the only way in Access to create custom menus. ******************************************************************************** * John King KING Systems * * CompuServe 72060,3706 Internet p00756@psilink.com * * MCI Mail 553-0074 Fax 804-270-6524 * ******************************************************************************** ========================================================================= Date: Tue, 7 Sep 1993 15:42:20 PST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jon D Gardner Subject: Re: one report / several queries >I have another problem. Is there any way one can have reports >separate from quesries? Let me try to explain. I have a report >which outputs data in a specified way to the printer. I would >like to be able to tell it to output only subsets of all the data. >For example, instead of printout out all the addresses, I would >like to print out address in Germany, or Germany and France, or >in Germany and entered after 15 Aug 93, or ... . >In other words, can a have a set of queries separate from a report? >Or, can I use different queries for the same report? >And more importantly !, how does one do that? >Or am I asking a rediculously simple question? >And if I am, I'd still like to know. >Many thanks for any help you can provide. >Best wishes, David David - When you open a report, you can specify the name of a filter, or you can stipulate a "where condition". Just enter Country="Germany" or an expression that will provide the filter that you want. ... Jon ... Jon_D_Gardner@ccm.hf.intel.com ========================================================================= Date: Wed, 8 Sep 1993 11:47:07 GMT+1200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Daniel Bar-Even Organization: National Library of New Zealand Subject: Query criteria Access' Order Entry database has this function... Function ConvertNulls (v As Variant, subs As Variant) As Variant If (IsNull(v)) Then ConvertNulls = subs Else ConvertNulls = v End If End Function ...which is neat for listing all records with data in a table if no criteria is entered. Eg Like ConvertNulls([EnterCriteriaHere],"*") My problem is that I want to able to list all records with or without data if no criteria is entered. Someone else must have found a solution to this problem. Any suggestions? TIA ********************************************************** Daniel Bar-Even (daniel.bar-even@baxter.natlib.govt.nz) Client Support Analyst National Library of New Zealand Te Puna Matauranga o Aotearoa P.O. Box 1467 Wellington New Zealand Ph: (04) 474-3000 Fax: (04) 474-3161 ********************************************************** ========================================================================= Date: Wed, 8 Sep 1993 08:34:00 +01 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Nilsson Jimmy, HK/R IDE" Subject: Integra Hi! ---- Is there anyone who have tested Integra's (am I using the right name of the product?) form- and report-builder together with VB 3.0? Was it good? Better than the form- and report-builder in Access? Do you use Integra rather than VB 3.0 on it own? Thanks in forward Jimmy Nilsson, University College of Karlskrona/Ronneby, Sweden Jimmy.Nilsson@ide.hk-r.se ### ========================================================================= Date: Wed, 8 Sep 1993 09:52:33 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Stefan Focke Subject: How to get the archived messages Hello! I remember, that it is possible to find the messages that were posted to this list. My problem is, that I do not remember how to do it. Could someone send me a description? Thank you Stefan Focke ---------------------------------------------------------------------- Stefan Focke Tel. 02241-14-3154 GMD-ISA e-mail: focke@gmd.de Postfach 1316 D - 53731 Sankt Augustin ********** MS-Word: From the guys who brought us EDLIN ******** ========================================================================= Date: Wed, 8 Sep 1993 08:40:28 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Arman Rivard Subject: Re: Query criteria In-Reply-To: Daniel Bar-Even "Query criteria" (Sep 8, 11:47am) On Sep 8, 11:47am, Daniel Bar-Even wrote: > Subject: Query criteria > Access' Order Entry database has this function... > > Function ConvertNulls (v As Variant, subs As Variant) As Variant > If (IsNull(v)) Then > ConvertNulls = subs > Else > ConvertNulls = v > End If > End Function > > ...which is neat for listing all records with data in a table if no > criteria is entered. Eg Like ConvertNulls([EnterCriteriaHere],"*") > > My problem is that I want to able to list all records with or without > data if no criteria is entered. Someone else must have found a > solution to this problem. Any suggestions? You can add an Or is Null in the Criteria section of your query. ConvertNulls([EnterCriteriaHere],"*") Or is Null Hope that helps. > > TIA > ********************************************************** > Daniel Bar-Even (daniel.bar-even@baxter.natlib.govt.nz) > Client Support Analyst > National Library of New Zealand > Te Puna Matauranga o Aotearoa > P.O. Box 1467 > Wellington > New Zealand Ph: (04) 474-3000 Fax: (04) 474-3161 > ********************************************************** >-- End of excerpt from Daniel Bar-Even -- Arman Rivard How do Peabody and Sherman get back ? ========================================================================= Date: Wed, 8 Sep 1993 07:48:18 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: How to get the archived messages In-Reply-To: Message of Wed, 8 Sep 1993 09:52:33 +0200 from To index the archives, send the command IND ACCESS-L to LISTSERV@INDYCMS.BITNET or LISTSERV@INDYCMS.IUPUI.EDU Find the log file you want (they are divided by month) and then send the command GET ACCESS-L LOGYYMM (where YYMM is Year/Month, i.e., LOG9309 for Sept. 93) to the LISTSERV address. Note that these commands should NOT be sent to the list but to LISTSERV. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 8 Sep 1993 12:20:57 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Searching Archives / Was:: Re: How to get the archived messages % To index the archives, send the command % Find the log file you want (they are divided by month) and then send the % command % to the LISTSERV address. % Note that these commands should NOT be sent to the list but to LISTSERV. I'd like to add one of my favourites (pardon the UK spelling): Searching LISTSERV archives. This is one of the most underused processes available. I keep the following available instead of crafting one from scratch. The search mechanisms for LISTSERV are extremely powerful, but this is the simple form and will usually get what you want. -------------------------------------------------------cut here------------------------------------------------------- //Looking JOB Echo=YES,Reply-via=MAIL Database search DD=Mine //Mine DD * Search NEEDLE in HAYSTACK index PRINT ALL -------------------------------------------------------cut here------------------------------------------------------- Substitute the keywords you are looking for in place of NEEDLE and the name of the list in place of HAYSTACK. You must always perform an index before you can print any messages from a search. If you are afraid there are a bazillion [sic] messages, omit the PRINT ALL and you'll receive just an index of the messages along with the summary for each message. PRINT ALL will print those messages qualifying for the search specifications. You'll receive at least one message which is the command file log, then a second file if the search was successful. Hope this helps. Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing ========================================================================= Date: Wed, 8 Sep 1993 11:41:30 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Searching Archives / Was:: Re: How to get the archived message s In-Reply-To: Message of Wed, 8 Sep 1993 12:20:57 EDT from <72410.2162@COMPUSERV E.COM> Absolutely correct, Phil, and I should have mentioned that. For those on VM systems, there is a utility called LDBASE that allows you to do interactive searches on list archives. Check with your local consultant as to where to get it...it should be available from LISTSERV as a $PACKAGE. (I got it so long ago I can't remember the file name.) -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 8 Sep 1993 12:37:47 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: field: date_last_modified: how to do it? In-Reply-To: Message of Tue, 7 Sep 1993 13:56:51 EDT from <##06@UTMARTN> Many thanks to Shannon Burgin for your help. Best wishes, david crookall ========================================================================= Date: Wed, 8 Sep 1993 12:46:08 CDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Crookall Organization: Simulation & Gaming - Project IDEALS Subject: Re: one report / several queries In-Reply-To: Message of Tue, 7 Sep 1993 15:42:20 PST from Thanks, Jon, for your help. One doesn't always see the obvious -- at least I don't. Best, David ========================================================================= Date: Wed, 8 Sep 1993 13:47:33 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Shannon Burgin <##06@UTMARTN.BITNET> Subject: Help! This file is already in use! I am trying to open an access database. I receive the message box, "This file is already in use." It is not in use. I tried repair and received the same message. First, how can I fix this? Second, how did this happen? (Additional notes: there was no power failure, etc. and my backup copy with the same date and time works.) ************************************************************************ * * * * Shannon Burgin * University of Tennessee/Martin * * Bitnet: ##06@UTMARTN.BITNET * Computer Center * * Phone: 901-587-7890 * 102 Cooper Hall * * Senior Systems Analyst * Martin, TN 38238 * * VM/VSE/CICS/VSAM/DLI/SQLDS * * ************************************************************************ ========================================================================= Date: Wed, 8 Sep 1993 15:03:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Long Subject: Security Lock-out Help! I decided that it was time to work on the "security" of my database. Well I did something wrong, and now I'm locked out of the "Users" and "Groups" under the security menu. I'm still called the "admin", but have restricted access. I backed up the database before I made changes, but it seems that it doesn't matter, I'm still locked out after a restore. What should I do next? ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems (N.Andover MA.) or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Wed, 8 Sep 1993 14:12:20 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Security Lock-out In-Reply-To: Message of Wed, 8 Sep 1993 15:03:00 EDT from You will need to reinstall SYSTEM.MDA in your ACCESS subdirectory from the installation disks. Whenever you get the urge to mess with security, good practice seems to be "back up SYSTEM.MDA!" so you can restore it if something untoward happens. Read the security white paper before you do any more security changes. Send the command GET SECURE TEXT to LISTSERV@INDYCMS.BITNET and the listserver will return a copy to you. HTH, -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Wed, 8 Sep 1993 14:14:37 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Help! This file is already in use! In-Reply-To: Message of Wed, 8 Sep 1993 13:47:33 EDT from <##06@UTMARTN> This happened to me once and the only thing I tried that worked was to exit Access and reboot the machine. ? Don't ask me why it worked, it just did. :) -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Thu, 9 Sep 1993 09:17:25 GMT+1200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Daniel Bar-Even Organization: National Library of New Zealand Subject: Re: Query criteria > From: Arman Rivard > On Sep 8, 11:47am, Daniel Bar-Even wrote: > > Subject: Query criteria > > Access' Order Entry database has this function... > > > > Function ConvertNulls (v As Variant, subs As Variant) As Variant > > If (IsNull(v)) Then > > ConvertNulls = subs > > Else > > ConvertNulls = v > > End If > > End Function > > > > ...which is neat for listing all records with data in a table if > > no criteria is entered. Eg Like > > ConvertNulls([EnterCriteriaHere],"*") > > > > My problem is that I want to able to list all records with or > > without data if no criteria is entered. Someone else must have > > found a solution to this problem. Any suggestions? > > > You can add an Or is Null in the Criteria section of your query. > ConvertNulls([EnterCriteriaHere],"*") Or is Null > > Hope that helps. > Sorry I should have been more specific (but thank you anyway Arman). I want to be able to list ONLY the records that match the criteria if it is entered and ALL the records including Nulls if no criteria is entered. ********************************************************** Daniel Bar-Even (daniel.bar-even@baxter.natlib.govt.nz) Client Support Analyst National Library of New Zealand Te Puna Matauranga o Aotearoa P.O. Box 1467 Wellington New Zealand Ph: (04) 474-3000 Fax: (04) 474-3161 ********************************************************** ========================================================================= Date: Wed, 8 Sep 1993 11:14:00 -0600 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "OOPS-EXT.-2104 WHERE ARE WE TODAY?" Subject: Help on getting around... Could someone please tell me how to get lists of lists on other subjects on the internet. Sorry to post this to the Access digest but I don't have an active connection to the internet and no other way of getting information about how to find my way around. Thanks in advance.... sean ========================================================================= Date: Thu, 9 Sep 1993 15:12:00 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Briganti, Joe" Subject: attaching to Paradox for Windows tables Greetings, recently, I asked this list about security violations I was experiencing when attempting to read Paradox for Windows tables form MS-Access. The answer was that P4W v1.0 is really Paradox 4.0 and hence Access cant read them causing the password/security pop-ups. P4W does not have any retro-conversions from v4.0 to v3.5 (as I believe does the dos version) however there is something you can do trick Access and indeed Paradox. Convert P4W tables v4.0 to a dbase (.dbf) file and then attach or import to it from Access. This will work until they change the dbase table format :-) -- Joe Briganti (j.briganti@trl.oz.au) ========================================================================= Date: Thu, 9 Sep 1993 08:09:40 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List Comments: Converted from OVVM to RFC822 format by PUMP V2.2 From: Michael Blankenstein Subject: Re: Help! This file is already in use! In-Reply-To: note of 09/08/93 15:15 Assuming that the db file has the a filename extension associated with Access, double-click on the database file from the filemanager. I also am not sure why this works. My access denied problems usually arise after compacting. Good Luck. Michael Blankenstein u7530mb@doevm.bitnet (e-mail) ========================================================================= Date: Thu, 9 Sep 1993 10:21:10 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: Re: Help! This file is already in use! % From: Nathan Brindle, INTERNET:NBRINDLE%INDYCMS.BITNET@uga.cc.uga.edu % This happened to me once and the only thing I tried that worked was to % exit Access and reboot the machine. ? Don't ask me why it worked, it % just did. I don't think one actually needs to reboot. I've always been able to exit & restart Windows and the problem has been corrected. Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing Carmel, Indiana ========================================================================= Date: Thu, 9 Sep 1993 10:31:59 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Phil Paxton <72410.2162@COMPUSERVE.COM> Subject: ABC vs. Ctrl-Enter I thought I'd post a follow-up regarding the use of ABC (Access Basic Code) vs. Ctrl-Enter. When the original poster mentioned seeing which the end-users preferred, that triggered a line of thinking on my part which I felt best to post/share: Remember, that by adding the ABC feature such [that] the user is able to use the Enter/Return key, you are almost promising them this will be there in the future. This means it should be on your list of things to test with future releases of the Access software as well as all revisions to your applications. It also means anyone following your path there will need to know this as you are destined to make some enemies (in retrospect) by being fancy now but if the need changes, it's not always fun to force users to change their habits "just because" (which is how it might seem to them)... Just some food for thought. Phil Paxton Development Editor SAMS/Prentice Hall Computer Publishing Carmel, Indiana ========================================================================= Date: Fri, 10 Sep 1993 16:23:00 +1000 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: K.ANDERSON@QUT.EDU.AU Subject: SUB ACCESS-L SUB ACCESS -L I hope this gets me on the ACCESS-L list. ========================================================================= Date: Fri, 10 Sep 1993 16:35:00 +1000 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: K.ANDERSON@QUT.EDU.AU Subject: ACCESS-L This is my first time really and will you respect me in the morning? If any one actually receives this could you please email me so I can send my real problem. Thanking you in advance Kevin Email ANDERSONK@QUT.EDU.AU ========================================================================= Date: Fri, 10 Sep 1993 16:41:00 +1000 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: K.ANDERSON@QUT.EDU.AU Subject: Update Master File from Details form I hope this works.. I am a new user of Access (yes another one). I have taught myself over the last week as I am evaluating packages and there are a number of functions I want any D/B package to do. The one I would like an answer to is: I want to update a control-total field in a master record based on the values in it's detail records. I can use a subform within the form but the detail file contains too much data. How can I update the master control total from the detail form?? I tried a function, but I cannot seem to send the control total value back to the macro/form. Please help.. Kevin (Klatu Barada Nicto Gort Klau Barada Nicto) Email Andersonk@qut.edu.au ========================================================================= Date: Fri, 10 Sep 1993 16:45:00 +1000 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: K.ANDERSON@QUT.EDU.AU Subject: IND ACCESS-L IND ACCESS-L ========================================================================= Date: Fri, 10 Sep 1993 08:14:00 CST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: PEJSAJ@UWSTOUT.BITNET Subject: Access-L Listserv Greetings, What listserver is this list on? I would like to change options, but the listserver doesn't seem to think I'm on the list (LISTSERV@INDYCMS is what I tried). Thanks, Jim Pejsa pejsaj@uwstout.edu ========================================================================= Date: Fri, 10 Sep 1993 08:49:56 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Bratten Subject: Scanning documents for Access database... I'm wanting to create an Access data-base to store and track scanned images of documents. What I'm looking for are techniques, software, etc... that will get the images in the smallest, ledgible format possible. I don't want to use OCR but only store the graphic image of the documents. The documents are transcripts (some are from foreign countrys and are handwritten), letters, test score reports, etc... What I'm hoping is to find an OLE-supporting application for the scanner so it can be used directly from the Access application to input the images to the database. However, a big consideration is the size of the image so maybe I'll need another application to manipulate the images into the best possible format. The application will need to handle a large volume of documents so, to make it functional, speed is also important. Presently, I have a Pentax IQ-Scan and the only software I have is an old version of WordScan. I've used it to scan documents but, thus far, the best I've been able to do for a letter-sized document is to put it in .pcx format and it's using 35 to 50K for a one-page document. Any suggestion will be highly appreciated. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | o__ | | Steve Bratten _.>/^_ BITNET < GE0793@SIUCVMB > | | Graduate School (_) \(_) INTERNET < GE0793@SIUCVMB.SIU.EDU > | | Southern Illinois University | | Carbondale IL 62901-4716 \o \o \o Graduate School | | Voice: (618) 453-4552 |> |> |> Southern Illinois University | | Fax: (618) 453-4562 < \ < \ < \ Carbondale, IL 62901-4716 | | | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^ ========================================================================= Date: Fri, 10 Sep 1993 08:51:37 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: Re: Scanning documents for Access database... In-Reply-To: Message of Fri, 10 Sep 1993 08:49:56 -0500 from WOW...that sounds like a LARGE .MDB...and while it would probably work, have you considered keeping each graphic on your hard drive and using an OLE link in a form to display the graphic image? That would keep your .MDB to a reasonable size and would also facilitate being able to retrieve each graphic individually outside of Access. Just a thought, I haven't actually tried this myself. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 10 Sep 1993 09:25:58 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Steve Bratten Subject: Scanning images for storage... > >WOW...that sounds like a LARGE .MDB...and while it would probably work, >have you considered keeping each graphic on your hard >drive and using an OLE link in a form to display graphic image? That >would keep your .MDB to a reasonable size and would also facilitate >being able to retrieve each graphic individually outside of Access. > Quite likely, you're exactly right about the method for storing the images. However, right now, my problem is getting them scanned and in a small file in a timely manner; I believe I'll need to have at least 3000 to 5000 images retrievable at one time so, no matter where they are stored, I need them to be as small as possible. >Just a thought, I haven't actually tried this myself. I've just set up a database to store and track OLE objects; spe- cifically, I'm embedding one graph from a Lotus Improv model (spread- sheet;) and it appears to be a good way (only embeds one graph in the Access table but provides access to all the other graphs and work- sheets in the Improv model with a double-click on the object frame. I like it and will probably try a similar method with the image-storing application. But, again, what I need first is a viable method of scanning the documents and getting them into a small file format, pre- ferrably using something that supports OLE. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ | o__ | | Steve Bratten _.>/^_ BITNET < GE0793@SIUCVMB > | | Graduate School (_) \(_) INTERNET < GE0793@SIUCVMB.SIU.EDU > | | Southern Illinois University | | Carbondale IL 62901-4716 \o \o \o Graduate School | | Voice: (618) 453-4552 |> |> |> Southern Illinois University | | Fax: (618) 453-4562 < \ < \ < \ Carbondale, IL 62901-4716 | | | ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^ ========================================================================= Date: Fri, 10 Sep 1993 09:26:04 MDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List Comments: Converted from PROFS to RFC822 format by PUMP V2.1 From: "Brian Keeler (403) - 471-8623" Subject: ACCESS-L In-Reply-To: note of 93-09-10 02:57 You made it to the net, I read your message.. have a good day.. Brian Keeler (403) - 471-8623 ..What is a CD-ROM ?? Application Services Coordinator 3 billion pits arranged Information Services Division in a 3 mile spiral... domain: briank@naitvm.nait.ab.ca ========================================================================= Date: Fri, 10 Sep 1993 13:48:23 EST Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Nathan Brindle Organization: IUPUI Student Activities Office (317) 274-3931 Subject: ACC-KB--again... Sorry all--between the CICA folks and myself it has been determined that the ACC-KB.ZIP file residing on CICA in pub/pc/win3/access is NOT the ACC-KB.EXE file which uploaded some time back (and which is still on CICA in pub/pc/win3/uploads/JUN93). The ACC-KB.ZIP file in the access directory seems to be from late June and is much larger than the file I uploaded (which was from February). It appears that it was zipped with PKZIP 2.04g as the copy of 1.10 I have here at work reports an unknown compression method. ACC-KB.ZIP is nearly a megabyte in size and the .HLP file it contains is 1.2mb uncompressed. I will try to unzip it tonight at home and let the list know how it goes. Again, sorry for the mixup. -----------------------------------------------------BITNET: NBRINDLE@INDYCMS Nathan C. Brindle, Administrative Specialist, Student Activities Office Indiana University Purdue University Indianapolis Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM Disclaimer: My opinions are my own. Indiana University can speak for itself. ------------------------------------------------------------------------------ ========================================================================= Date: Fri, 10 Sep 1993 15:54:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Rick.Klingensmith" Subject: ACC-KB.ZIP I successflly unzipped ACC-KB.ZIP file residing on CICA in pub/pc/win3/access using PKZIP 2.04. After I renamed it and got the nasty error message I tried to unzip it and all worked. Rick ========================================================================= Date: Fri, 10 Sep 1993 15:26:40 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Rick Huff Subject: Join with Two Fields Is it possible to join two tables using two fields? For example I want two tables joined on customer number and purchase order number. I have tried doing this graphically by dragging the additional field from one table to the other, but this creates another join (instead of a further qualified single join). The next try was to modify the SQL for the query. I think I want something like this: SELECT * FROM CUSTOMER, SUMMARY LEFT JOIN CUSTOMER ON CUSTOMER.CustNum = SUMMARY.CustNum AND CUSTOMER.PONum = SUMMARY.PONum; However, when I attempt such a join, I get the following message: "Can't create join: CUSTOMER.CustNum = SUMMARY.CustNum AND CUSTOMER.PONum = SUMMARY.PONum". The on-line help gives three reasons why this message is displayed none of which are true. Has anybody done this successfully? Thanks. Rick Huff, Senior Systems Analyst (409) 845-8454 (rick@billnext.tamu.edu) CIS, Computing and Information Services, Texas A&M University ========================================================================= Date: Fri, 10 Sep 1993 15:56:01 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Mark Paskill <98521899@WSUVM1.BITNET> Subject: Re: Join with Two Fields In-Reply-To: Message of Fri, 10 Sep 1993 15:26:40 -0500 from I hope I understand your question - if so why not make both fields key fields?? ========================================================================= Date: Sat, 11 Sep 1993 17:30:00 +1000 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Kevin Anderson Subject: Requery of a subform Hi to everyone, Background =========== I have a main form with a sub-form. The sub-form is based on a query that returns totals from a details file to the main form. The subform is readonly and is never entered from the main form. On entry the subform works fine. Whenever I read another record forward or backward on the main form the subform totals reset and recalculate ....terrific. But, Problem ======= When I use a button from the main form to go to another form, add values to the detail records on which the query based subform is based, and return to the original form via a "close button" the totals are not updated. Is there a way of "re-querying" the sub-form on return to the main form. I have tried using the requery command from a macro using the "control name" of the subform but no joy. I would be most grateful for a soultion to what I am sure is a very simple problem. In anticipation, a warm thank you. Kevin Internet Address: ANDERSONK@QUT.EDU.AU (Klatu Barada Nicto GORT Klatu Barada Nicto) ========================================================================= Date: Sun, 12 Sep 1993 12:26:21 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Rick Huff Subject: Re: Join with Two Fields In-Reply-To: <9309102259.AA15287@billnext.tamu.edu> I can make them a multiple field index, but I cannot make them a multiple field key because one of the fields is blank in some of the records. Rick Huff, Senior Systems Analyst (409) 845-8454 (rick@billnext.tamu.edu) CIS, Computing and Information Services, Texas A&M University On Fri, 10 Sep 1993, Mark Paskill wrote: > I hope I understand your question - if so why not make both fields key fields? ? ========================================================================= Date: Mon, 13 Sep 1993 09:47:15 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Stefan Focke Subject: Re: Requery of a subform >Is there a way of "re-querying" the sub-form on return to the main >form. I have tried using the requery command from a macro using the >"control name" of the subform but no joy. > DoCmd Requery Forms!
!.ControlName Hope that helps Stefan ---------------------------------------------------------------------- Stefan Focke Tel. 02241-14-3154 GMD-ISA e-mail: focke@gmd.de Postfach 1316 D - 53731 Sankt Augustin ********** MS-Word: From the guys who brought us EDLIN ******** ========================================================================= Date: Mon, 13 Sep 1993 15:11:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Long Subject: Automatic Encryption I would like to have my database automatically encrypt itself whenever a user closes out of the database. I've looked around for a command before completely "exiting" but have failed to see anything. Is it possible to automatically encrypt?...or do I have to instruct my users to do it manually? Thanks ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems (N.Andover MA.) or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Mon, 13 Sep 1993 15:13:19 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jim Renaud Subject: Internal Database Error I have some Access Basic code that checks to see if a variable (defined as Variant, by default) contains null data. For example: If IsNull(Country) then ... Endif This has always worked for me before. Today, code that has been working for a long time suddenly died when I called it with a Null value (the table was empty in which a field was referenced). Anyway, I get the following message now whenever I reference the variable containing the Null: Internal Database Error (-1603). This message pops up when I try to reference the variable from within the immediate window as well. I don't find this error documented anywhere. Does anyone have an idea what this means? I just found this and have not had time to try this code with other routines and data. ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Mon, 13 Sep 1993 15:19:24 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Jim Renaud Subject: Record selectors Has anyone found a way to determine in Access Basic which records in a form (continuous detail section) have been selected in the left hand Record Selector area. You know, this is the area that if selected, you can delete records by just hitting the delete key. I want to have a routine determine which records the user selected so I can do some special processing on them. I get the feeling that this is going to require that I open my VB 3.0 box so that I can get access (no pun intended) to the list structure of the form and handle the mouse down and drag events. Any thoughts??? ----------------------------------------------------------------------- Jim Renaud [Standard Disclaimer] Amdahl Corporation M/S 205 Phone: 408-992-2662 Bldg. M3 Room 235 Fax: 408-773-0833 1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com Sunnyvale, CA 94088-3470 ========================================================================= Date: Tue, 14 Sep 1993 17:31:31 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Eric Laverdiere Organization: Ecole des Hautes Etudes Commerciales de Montreal Subject: subscribe to access-l@indycms Eric Laverdiere Subscription for access discussion group ========================================================================= Date: Fri, 17 Sep 1993 09:23:09 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Stacer Subject: Report name in reports Is there a way to get the report name in a report similary to a =now() for the date and time? ========================================================================= Date: Fri, 17 Sep 1993 11:40:09 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Dave Finley Subject: Using Access on Pathworks network. Has anyone on the list used Access under DEC Pathworks? It is not listed as an "officially-supported network" in the Access documentation, but the MS Knowledge base implies that you can run Access under Pathworks. ========================================================================= Date: Fri, 17 Sep 1993 16:06:26 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: schmitzj@ADADV1.MDC.COM SUBSCRIBE Jeff Schmitz ========================================================================= Date: Fri, 17 Sep 1993 16:59:23 -0500 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: mowryc@MDTSVX.MDC.COM SUBSCRIBE faccess-l Chris Mowry ========================================================================= Date: Mon, 20 Sep 1993 08:48:00 +0100 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List Comments: Sent using PMDF-822 , routing is done by ECNICE From: Bart Schaap Subject: Re: Using Access on Pathworks network. Hello David, Yes, we use Access (1.0) under Pathworks version 4.1. We have installed it re- cently and it seems to work well. The securety features of Access are however a bit tricky, but we are working on that. Installation of Access is not very elegant but after some trial and error we managed to set it up. Bart Schaap Energy research foundation of the Netherlands (ECN) Holland ========================================================================= Date: Mon, 20 Sep 1993 13:10:27 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Greg Fairnak Organization: The American University Subject: Re: Using Access on Pathworks network. In-Reply-To: Message of Fri, 17 Sep 1993 11:40:09 EDT from Pathworks is really Lan_Manager under neath. ========================================================================= Date: Mon, 20 Sep 1993 13:40:14 CDT Reply-To: tntow@timtow.b1.ingr.com Sender: Microsoft Access Database Discussion List From: Tim Tow Subject: Re: Report name in reports > Date: Fri, 17 Sep 1993 09:23:09 -0500 > From: David Stacer > Subject: Report name in reports > > Is there a way to get the report name in a report similary to a > =now() for the date and time? Not quite that simple... :-) First, write an Access Basic function to get the reportname (that has focus): Function ActiveReport () As String Dim ObjActiveReport As Report Set ObjActiveReport = screen.ActiveReport ActiveReport = ObjActiveReport.formname End Function Then, define a text box on your report and call the function as the Control Source: =ActiveReport() ---------------------------------------------------------------------------- Tim Tow, CPA Phone: 205-730-8234 Intergraph Corporation Fax: 205-730-2164 Mailstop: HQ011 Mailpath: tntow@ingr.com Huntsville, AL 35894-0001 ========================================================================= Date: Tue, 21 Sep 1993 10:38:00 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Ellington, Robert W (Bob)" Subject: Determine Add Mode on Before Update Hello, Has anyone figured out how to determine that you are in ADD mode on a form thru a before update property. I need to input data in some fields only during an ADD. Any help appreciated. Bob Ellington rwelling@ingr.com ========================================================================= Date: Tue, 21 Sep 1993 11:48:35 -0600 Reply-To: jao9w265@aurora.cdev.com Sender: Microsoft Access Database Discussion List Comments: Warning -- original Sender: tag was jao9w265@AURORA.CDEV.COM From: "John A. Olson" Subject: Line Continuation in AB Module Does anyone know how I can continue a line of code on the next physical line? What I mean is, if a line of code is too long to be displayed continuously on the screen, can it be "broken" and spill onto the next line? I know this can be done in 'C', but can it be done in Access Basic? Any help would be much appreciated. Thanks! John A. Olson jao9w265@aurora.cdev.com Computing Devices International Bloomington, MN ========================================================================= Date: Wed, 22 Sep 1993 13:22:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Long Subject: Replace field value w/ previous On a form I would like a particular field to retain the value from the previous record. This will facilitate data input where a field will contain like info for x number of records. I know that pressing Ctrl+" will return the value from the previous record, but I would prefer it to automatically default to that value. I,ve been searching for a solution...even trying the sendkey to that control...but with no success. Any help in pointing me in the right direction will be appreciated. Thanks ============================================================================== David B. Long E-Mail=> mvdbl@mvgpg.att.com AT&T Network Systems (N.Andover MA.) or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Thu, 23 Sep 1993 08:13:30 -0600 Reply-To: jao9w265@aurora.cdev.com Sender: Microsoft Access Database Discussion List Comments: Warning -- original Sender: tag was jao9w265@AURORA.CDEV.COM From: "John A. Olson" Subject: Code Editing I apologize in advance if this message has been received by the list already. I got a strange message when I sent it the first time which indicated that it never was distributed. If it was, please forgive this repeat. Subject: Line Continuation in AB Module Does anyone know how I can continue a line of code on the next physical line? What I mean is, if a line of code is too long to be displayed continuously on the screen, can it be "broken" and spill onto the next line? I know this can be done in 'C', but can it be done in Access Basic? Any help would be much appreciated. Thanks! John A. Olson jao9w265@aurora.cdev.com Computing Devices International Bloomington, MN ========================================================================= Date: Thu, 23 Sep 1993 15:43:41 +0200 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Stefan Focke Subject: Re: Replace field value w/ previous >On a form I would like a particular field to retain the >value from the previous record. This will facilitate >data input where a field will contain like info for >x number of records. >I know that pressing Ctrl+" will return the value from the >previous record, but I would prefer it to automatically >default to that value. In the help-file that is available from cica they say, that you have to store the values from the last form (on exit) and write the values in the new form (on enter). Greetings Stefan Focke -- Stefan Focke, GMD-I8, D-53731 Sankt Augustin, focke@gmd.de ********** MS-Word: From the guys who brought us EDLIN ******** ========================================================================= Date: Thu, 23 Sep 1993 09:15:44 -0600 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Tim Mackay Subject: Re: Replace field value w/ previous >On a form I would like a particular field to retain the >value from the previous record. This will facilitate >data input where a field will contain like info for >x number of records. >I know that pressing Ctrl+" will return the value from the >previous record, but I would prefer it to automatically >default to that value. >I,ve been searching for a solution...even trying the sendkey >to that control...but with no success. >Any help in pointing me in the right direction will be >appreciated. >Thanks >============================================================================== > David B. Long E-Mail=> mvdbl@mvgpg.att.com > AT&T Network Systems (N.Andover MA.) or=> d.b-long@channel1.com > Quality Engineering Tele=> 508-960-3683 >============================================================================== I had the same problem. My solution was to use a DLast(...) function for the default value. Tim Mackay |paper-net:Marquette Electronics, Inc internet: tmackay@mei.com | 8200 W Tower Ave voice-net:(414) 362-2765 | Milwaukee, WI 53223 ========================================================================= Date: Thu, 23 Sep 1993 11:33:35 -0700 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Roger Lurie Subject: Attached Sybase Tables Has anyone worked with large remote Sybase SQL Server tables attached to an Access database? I have some Sybase tables with up to 5 million records and am experiencing some difficulties using ODBC drivers included with Access 1.1 to query and retrieve records from the Sybase database. The response time seems to worsen with each additional query run during an Access session. Has anyone else experienced these problems? If so, what have you done to correct them? Are there more reliable ODBC drivers available from Sybase or QE Software than the ones provided by Microsoft? ------------------------------------------------------------------------- Roger Lurie Arizona State University, Administrative Information Technology Tempe, Arizona 85287-0101 Telephone: (602) 965-4433 Fax: (602) 965-0819 Internet: icsral@asuvm.inre.asu.edu Bitnet: icsral@asuacad ------------------------------------------------------------------------- ========================================================================= Date: Thu, 23 Sep 1993 16:27:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: mkro Subject: Re: Code Editing DISREGARD IF THIS HAS ALREADY BEEN ANSWERED....OUR GATEWAY IS SLOW TODAY! FROM WHAT I WAS TOLD IN AN Microsoft University Access Programming Class, NO! Sorry, I guess that's asking to much! Cheers, Mike Kroeger mkro.dis-pc@bmailin.itg.ti.com ------------- Original Text From JAOLSON @ SMTP (John A. Olson) {owner-access-l@INDYCMS.IUPUI.EDU}, on 9/23/93 8:13 AM: I apologize in advance if this message has been received by the list already. I got a strange message when I sent it the first time which indicated that it never was distributed. If it was, please forgive this repeat. Subject: Line Continuation in AB Module Does anyone know how I can continue a line of code on the next physical line? What I mean is, if a line of code is too long to be displayed continuously on the screen, can it be "broken" and spill onto the next line? I know this can be done in 'C', but can it be done in Access Basic? Any help would be much appreciated. Thanks! John A. Olson jao9w265@aurora.cdev.com Computing Devices International Bloomington, MN *** uuencoded BINARY enclosure *** The section below this line contains an MHS attachment. To extract it, copy this message to a file and use the program UUDECODE. For information on using UUDECODE on UNIX systems, type the command 'man uudecode'. The attachment name was originally: ATTRIBS.BND --------------- begin 644 attribs.bnd M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``87+&IK*```````0$`````````%0`#```` M````````````````````````57-E(%!R;W!O6]N92!K;F]W(&AO=R!)(&-A;B!C;VYT:6YU M92!A(&QI;F4@;V8@8V]D92!O;B!T:&4@;F5X="!P:'ES:6-A;`IL:6YE/R`@ M5VAA="!)(&UE86X@:7,L(&EF(&$@;&EN92!O9B!C;V1E(&ES('1O;R!L;VYG M('1O(&)E(&1I2!H96QP('=O=6QD(&)E M(&UU8V@@87!PP$`;X%`9`&`6(' M`30(`08)`=@)`:H*`7P+```1``````````0`NP$````````````````````` M`````%1E>'3T`$1)4U)%1T%21"!)1B!42$E3($A!4R!!3%)%0419($)%14X@ M04Y35T52140N+BXN3U52($=!5$5705D@25,@4TQ/5R!43T1!62$*"D923TT@ M5TA!5"!)(%=!4R!43TQ$($E.($%.($UI8W)O2P@22!G=65S Organization: University Of East London Subject: Snaking column headers I'm printing a report in 3 vertical columns and I'd like an identical heading at the top of each column. I'd be grateful if anyone can tell me a way to do it. Thanks. ========================================================================= Date: Fri, 24 Sep 1993 08:45:00 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: David Long Subject: Replace field value w/ previous Thanks to Ron Apland In your confirmation of my method of using a macro in which I use sendkey...you showed me that the characters should be ^('). I was using ^" I saw in the book where I was supposed to place the quote in parentheses (LRpg.435) and saw how I was misled by User Guide, pg. 353 says to use a double quote...it should read single. I call the macro in the "On Enter" field for the control, and it works just fine! Thanks again ============================================================================== David B. Long E-Mail=> mvdbl@mvgsd.att.com AT&T Network Systems (N.Andover MA.) or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Fri, 24 Sep 1993 10:41:00 LCL Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: mkro Subject: MSA Database Window Size This may be a dumb question.... When you first pull up a database when you enter MSA, the Database windows is the first thing to come up(in my case). How do you get MSA to remember SIZE changes to this window? I have several tables in the database, and it is would be nice to see them all, or as many as possible, without having to use the scroll bars! Whenever I resize this window, and exit out, the next time I open the window to go to table view, it is shrunk back to the original size! *** uuencoded BINARY enclosure *** The section below this line contains an MHS attachment. To extract it, copy this message to a file and use the program UUDECODE. For information on using UUDECODE on UNIX systems, type the command 'man uudecode'. The attachment name was originally: ATTRIBS.BND --------------- begin 644 attribs.bnd M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``;O&VIK*```````35-!($1A=&%B M87-E(%=I;F1O=R!3:7IE```````````````````````````````````````` M```````````````````````````````````````````````````````````` M`&UK'0``E1H:7,@;6%Y(&)E M(&$@9'5M8B!Q=65S=&EO;BXN+BX*("`*("`@5VAE;B!Y;W4@9FER6]U(&5N=&5R($U302P@=&AE($1A=&%B M87-E('=I;F1O=W,@:7,@=&AE(&9I6]U(&=E="!-4T$@=&\@ Sender: Microsoft Access Database Discussion List From: David Long Subject: Incrementing numeric field I'm developing a database that stores survey information. Each survey has 30 questions. I have chosen to store each question response as a record. To facilitate data input, I would prefer the data input field which designates the question # to increment itself after every record input (1-30) and then cycle back to question #1. This will eliminate the need for the data input person from typing in the question number. I've thought on various ways I could approach this issue. One is to write some code (new to me...could take some time) that will increment and return a value to the field after every record input. or Increment through a series of subforms, related specifically to the question being inputed....so the default value can be set for the particular question. Any Ideas on these or alternative approaches would be greatly appreciated. Thanks ============================================================================== David B. Long E-Mail=> mvdbl@mvgsd.att.com AT&T Network Systems (N.Andover MA.) or=> d.b-long@channel1.com Quality Engineering Tele=> 508-960-3683 ============================================================================== ========================================================================= Date: Sat, 25 Sep 1993 12:42:46 PDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: schuck@SFU.CA Subject: Re: Incrementing numeric field In-Reply-To: <9309250000.AA20466@whistler.sfu.ca>; from "David Long" at Sep 24, 93 9:07 am > > I'm developing a database that stores survey information. > Each survey has 30 questions. > I have chosen to store each question response as a record. > To facilitate data input, I would prefer the data input field > which designates the question # to increment itself after every > record input (1-30) and then cycle back to question #1. > This will eliminate the need for the data input person from > typing in the question number. > > I've thought on various ways I could approach this issue. > One is to write some code (new to me...could take some time) that > will increment and return a value to the field after every record input. > or > Increment through a series of subforms, related specifically to the > question being inputed....so the default value can be set for the particular > question. > > Any Ideas on these or alternative approaches would be greatly > appreciated. > I'd create these records: t_Response -- one for each responder id_RESPONSE -- a counter field nm_name -- or some identifier to label the responder ... t_Response_Detail -- one for each question answered by a responder id_RESPONSE_DETAIL - counter id_response -- from the Response record id_question_num -- the question number t_Question -- one for each question id_QUESTION -- the question number nm_question -- the question Your main form would just be the t_Response table the subform would be a query link t_Question to t_RESPONSE_DETAIL with an outer join? and the criteria of id_response equal to id_response on the mainform I haven't tried, but some variation shoukld work and you wouldn't need code. When you went to the next record on the main form, you should get full or empty records on the subform, one for each question. ========================================================================= Date: Sat, 25 Sep 1993 17:05:25 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Harry Yeatts Subject: Re: Incrementing numeric field In-Reply-To: Message of Fri, 24 Sep 1993 09:07:00 EDT from On Fri, 24 Sep 1993 09:07:00 EDT David Long said: >I'm developing a database that stores survey information. >Each survey has 30 questions. >I have chosen to store each question response as a record. >To facilitate data input, I would prefer the data input field >which designates the question # to increment itself after every >record input (1-30) and then cycle back to question #1. >This will eliminate the need for the data input person from >typing in the question number. > >[stuff deleted] David: I've just finished designing a database to handle three surveys and I worked it a little differently than you propose. I designed a data entry form using option groups (with check boxes that register a numerical value for a response [i.e., 4 for "read all," 3 for "read most," 2 for "read some," 1 for "browse," and 0 for "read none]) and text boxes for subjective answers (as memos). To get to what you wanted, I set the form for continuous. This way the data entry person can head on to the next set of responses without doing anything special. (I put the index number for the form in the upper-right-hand corner so they can write on the paper form which ones they've done.) This has worked extremely well so far. Our date entry people have little experience with data entry or databases, but they've found it easy to use. They don't mind tabbing between questions and use the page down button with ease. I made the data entry form look as much like the paper form as possible so it's easy for them to keep their places. I know this isn't exactly what you asked, but I thought I'd pass on my experiences with surveys. If you have any questions about this...or want more info, just ask. Harry Yeatts (HYEATTS) INTERNET: VTVM1.CC.VT.EDU Virginia Tech BITNET: VTVM1 Blacksburg, Virginia PHONE: 703-231-5141 ========================================================================= Date: Sun, 26 Sep 1993 16:09:37 EDT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Greg Fairnak Organization: The American University Subject: dynaset as a source of a form I am looking for a few suggestions: If I process a query and it is successful I have a found set of data. Is there an easy way to connect the foundset to a forms property? In essence, when I run a query, ("select * from people where height > 5"), from form A, form B would show me all found set records. I would like to use a form to see the person's name and address. How do I do this? Can I connect a dynaset to form B's rowsource property? Any ideas appreciated, regards, Greg ========================================================================= Date: Sun, 26 Sep 1993 15:05:37 PDT Reply-To: thamilto@pcocd2.intel.com Sender: Microsoft Access Database Discussion List From: "Tony Hamilton - FES ERG~" Subject: Re: dynaset as a source of a form In-Reply-To: <9309262139.AA00134@hermes.intel.com>; from "Greg Fairnak" at Sep 26, 93 4:09 pm > > I am looking for a few suggestions: > > If I process a query and it is successful I have a found set of data. > Is there an easy way to connect the foundset to a forms property? > In essence, when I run a query, ("select * from people where height > 5"), > from form A, form B would show me all found set records. > I would like to use a form to see the person's name and address. > How do I do this? Can I connect a dynaset to form B's rowsource property? > > Any ideas appreciated, > > regards, > > Greg Greg, you can assign a table, query, or SQL statement as the source of any form or list/combo-box. Dynasets are a construct for use in BASIC only, as are snapshots. In forms, you are dealing with only tables, queries, or SQL statements. SQL statements, I have found, _can_ be dynamic for list and combo boxes. -- Tony Hamilton | -Intel Corporation | voice: 916-356-3070 --Folsom Engineering Services | mailstop: FM2-55 ---Engineering Resource Group | email: thamilto@pcocd2.intel.com ----Software Technician | ========================================================================= Date: Tue, 28 Sep 1993 15:19:21 -0400 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: Arman Rivard Subject: Oncurrent Controls I have a subform which attempts to modify the data on its main form. This all works fine when the main form is opened , yet when I first open the main form it seems the subform opens first, executes the oncurrent and can't find the control. Access support says thats how it works |-( Has anyone found a workaround ?? I really need to use the record selectors on the subform and the oncurrent rather than onenter. Too much to ask ? Thanks for any help. -- Arman Rivard How do Peabody and Sherman get back ? ========================================================================= Date: Wed, 29 Sep 1993 12:40:15 SAT Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: taha alesayi Organization: King Fahd University of Petroleum and Minerals, S.A. Subject: registration "ok" ========================================================================= Date: Wed, 29 Sep 1993 11:30:00 +01 Reply-To: Microsoft Access Database Discussion List Sender: Microsoft Access Database Discussion List From: "Nilsson Jimmy, HK/R IDE" Subject: Notebooks with databases Hi! ---- I am in big trouble and I hope someone out there perhaps can help me!!! I am supposed to build an application which is going to be used by people who has notebooks. They would like to take the database with them when they go home at night and when they travel. When they are back at the office they log on to their database-server and the database in the notebook get the new information and puts it new information. This is what is called replication of databases. This functionality is found in Lotus Notes but I would like to use MS Access as the database. I could build it myself, but the more you think about it, the more complex it seems. I rather would buy a product but I can't find any. Do anybody out there know about a product which give me the replication of database-functionality??? Please help me! Regards, Jimmy Nilsson Jimmy.Nilsson@ide.hk-r.se ###